The UserProcess table is for internal iMIS use only, and has one field in it called HOST_PROCESS. This table is used for licensing and tracks the number of users connected to iMIS. When users connect to the server, a unique host id is created in the HOST_PROCESS field, which identifies the connection. If you enter the SQL query, SELECT * FROM UserProcess, the result displays one number for each user connected to the database.
When a user logs in, iMIS performs the following:
DELETE UserProcess
WHERE (not exists
(SELECT * FROM master..sysprocesses p
WHERE UserProcess.HOST_PROCESS = p.hostprocess))
or (HOST_PROCESS = host_id())
This clears out any unattached processes from the UserProcess table.
For SQL Server
UserProcess.HOST_PROCESS comes from "Select host_id ()" for the current user.
This corresponds to the Host Process ID for the client. This does not get passed back to any of the SQL Server diagnostic tools (Enterprise Manager or Trace).
For Sybase
UserProcess.HOST_PROCESS comes from "Select connection_property ('Number')" for the current user.
In SQL Central, this maps to the Connection ID column in the "Connected Users" folder under the database in question.
10.6 Production Release. Updated 12/12/2005 3:17:35 PM
© Copyright by Advanced Solutions International, Inc.
All rights reserved.